package com.example.demo.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.example.demo.entity.MtrEntity;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface MtrDao extends BaseMapper<MtrEntity> {

    @Select("SELECT id, mtr_name FROM bs_mtr_archive WHERE MATCH (mtr_name) AGAINST (+#{mtrName} IN BOOLEAN MODE);")
    List<MtrEntity> getMtrByName(@Param("mtrName") String mtrName);
}
